CREATE TABLE [dbo].[u_f2_00_varios]
(
[Id] [int] NOT NULL,
[idCui] [int] NOT NULL,
[construccion] [int] NULL,
[calle] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[numero] [int] NULL,
[referencia] [varchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[anioMayorParteConstruccion] [int] NULL,
[idConstOrig] [int] NULL,
[observaciones] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[idTipoEstr] [int] NULL,
[idEstadoTipoEstr] [int] NULL,
[idTipoTechoEstr] [int] NULL,
[idEstadoTechoEstr] [int] NULL,
[idTipoTechoCub] [int] NULL,
[idEstadoTechoCub] [int] NULL,
[idTipoParedMaterial] [int] NULL,
[idEstadoParedMaterial] [int] NULL,
[idTipoParedTerm] [int] NULL,
[idEstadoParedTerm] [int] NULL,
[subsuelo] [int] NULL,
[plantabaja] [int] NULL,
[plantaalta] [int] NULL,
[totalPlantas] [int] NULL,
[F2completo] [int] NOT NULL,
[supCubierta] [int] NULL,
[supCubierta_us_administ] [int] NULL,
[supSemicubierta] [int] NULL,
[supSemicubierta_us_administ] [int] NULL,
[superficieTotal] [int] NULL,
[superficieTotal_us_administ] [int] NULL,
[idServicioComedor] [int] NULL,
[idRtaServicioComedorA] [int] NULL,
[idRtaServicioComedorB] [int] NULL,
[idRtaServicioComedorC] [int] NULL,
[idRtaServicioComedorD] [int] NULL,
[idRtaServicioComedorE] [int] NULL,
[IdRtaTabElecGen] [int] NULL,
[IdRtaLlaveTabElecGen] [int] NULL,
[IdRtaProtecTabElecGen] [int] NULL,
[IdRtaPTierTabElecGen] [int] NULL,
[IdRtaTabElecSec] [int] NULL,
[IdRtaLlaveTabElecSec] [int] NULL,
[IdRtaProtecTabElecSec] [int] NULL,
[IdRtaPTierTabElecSec] [int] NULL,
[3_1_1_IdEstRedPub] [int] NULL,
[3_1_2_IdEstBomManual] [int] NULL,
[3_1_3_IdEstBomAuto] [int] NULL,
[3_1_4_IdEstPluvial] [int] NULL,
[3_1_5_IdEstMolino] [int] NULL,
[3_1_6_IdEstMananVert] [int] NULL,
[3_1_7_IdEstCamCister] [int] NULL,
[3_1_8_IdEstCedida] [int] NULL,
[3_1_9_IdEstEnvasada] [int] NULL,
[3_1_10_IdEstOtro] [int] NULL,
[3_2_1_IdEstAljibe] [int] NULL,
[3_2_2_IdEstCisterna] [int] NULL,
[3_2_3_IdEstTanqElev] [int] NULL,
[3_2_4_IdEstTorrTanq] [int] NULL,
[3_2_5_IdEstBidonBot] [int] NULL,
[3_2_6_IdEstOtro] [int] NULL,
[3_3_1_IdEstAbastBanos] [int] NULL,
[3_3_2_IdEstAbastCocina] [int] NULL,
[3_3_3_IdEstAguaIncendio] [int] NULL,
[3_3_4_IdEstServRiego] [int] NULL,
[3_4_1_IdEstTratPotab] [int] NULL,
[3_4_1_IdRtaTratPotab] [int] NULL,
[3_4_2_IdEstContSanit] [int] NULL,
[3_4_2_ContSanitCant] [int] NULL,
[4_1_IdEstRedPub] [int] NULL,
[4_2_IdEstPlantTrat] [int] NULL,
[4_3_IdEstCamPozo] [int] NULL,
[4_4_IdEstPozoAbs] [int] NULL,
[4_5_IdEstLetrina] [int] NULL,
[4_6_IdEstOtroSist] [int] NULL,
[5_1_IdEstRedPub] [int] NULL,
[5_2_IdEstZepelin] [int] NULL,
[5_3_IdEstGasTubo] [int] NULL,
[5_4_IdEstGasGarraf] [int] NULL,
[5_5_IdEstLenaCarb] [int] NULL,
[5_6_IdEstOtro] [int] NULL,
[6_1_1_IdEstRedPub] [int] NULL,
[6_1_2_IdEstGrupElect] [int] NULL,
[6_1_2_GrupElectPotenc] [int] NULL,
[6_1_2_IdRtaGrupElectComb] [int] NULL,
[6_1_3_IdEstPanFotov] [int] NULL,
[6_1_3_PanFotovPotenc] [int] NULL,
[6_1_3_IdRtaPanFotovBater] [int] NULL,
[6_1_4_IdEstGenEolic] [int] NULL,
[6_1_4_GenEolicPotenc] [int] NULL,
[6_1_4_IdEstGenEolicBater] [int] NULL,
[6_1_5_IdEstOtro] [int] NULL,
[7_1_IdEstSistDetec] [int] NULL,
[7_2_IdEstInstCent] [int] NULL,
[7_2_InstCentCantBocas] [int] NULL,
[7_3_IdEstMatafA] [int] NULL,
[7_3_MatafACant] [int] NULL,
[7_3_IdRtaMatafACarga] [int] NULL,
[7_4_IdEstMatafABC] [int] NULL,
[7_4_MatafABCCant] [int] NULL,
[7_4_IdRtaMatafABCCarga] [int] NULL,
[7_5_IdEstMatafABCHalog] [int] NULL,
[7_5_MatafABCHalogCant] [int] NULL,
[7_5_IdRtaMatafABCHalogCarga] [int] NULL,
[7_6_IdEstMatafBC] [int] NULL,
[7_6_MatafBCCant] [int] NULL,
[7_6_IdRtaMatafBCCarga] [int] NULL,
[7_7_IdEstSalEmerg] [int] NULL,
[7_7_SalEmergCant] [int] NULL,
[7_8_IdRtaBarralAntip] [int] NULL,
[7_9_IdEstLuzEmerg] [int] NULL,
[7_10_IdEstPlanoEvac] [int] NULL,
[7_10_IdEstSimulEvac] [int] NULL,
[7_11_IdEstEscalExt] [int] NULL,
[7_12_IdEstSenaliz] [int] NULL,
[7_13_IdEstAlarmaRob] [int] NULL,
[7_14_IdEstAlarmaCatast] [int] NULL,
[7_15_IdEstVidSeg] [int] NULL,
[7_16_IdEstOtro] [int] NULL,
[8_1_IdEstAcens] [int] NULL,
[8_1_AcensCant] [int] NULL,
[8_1_IdRtaAcensManten] [int] NULL,
[8_2_IdEstMontCargEsc] [int] NULL,
[8_2_MontCargEscCant] [int] NULL,
[8_2_IdRtaMontCarManten] [int] NULL,
[8_3_IdEstSanitDisc] [int] NULL,
[8_3_SanitDiscCant] [int] NULL,
[8_4_IdEstRampas] [int] NULL,
[8_5_IdEstSenLumi] [int] NULL,
[8_6_IdEstSenSonor] [int] NULL,
[8_7_IdEstPisoCiego] [int] NULL,
[8_8_IdEstParedCiego] [int] NULL,
[8_9_IdEstOtro] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[u_f2_00_varios] ADD CONSTRAINT [PK_u_f2_00_varios] PRIMARY KEY CLUSTERED  ([Id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[u_f2_00_varios] WITH NOCHECK ADD CONSTRAINT [FK_u_f2_00_varios_u_fg_00_varios] FOREIGN KEY ([idCui]) REFERENCES [dbo].[u_fg_00_varios] ([Id]) NOT FOR REPLICATION
GO
ALTER TABLE [dbo].[u_f2_00_varios] NOCHECK CONSTRAINT [FK_u_f2_00_varios_u_fg_00_varios]
GO
